{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_csv('天眼查219结果-1.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>公司名称</th>\n",
       "      <th>法定代表人</th>\n",
       "      <th>注册资本</th>\n",
       "      <th>成立日期</th>\n",
       "      <th>经营状态</th>\n",
       "      <th>所属省份</th>\n",
       "      <th>所属市区</th>\n",
       "      <th>所属区县</th>\n",
       "      <th>公司类型</th>\n",
       "      <th>统一信用代码</th>\n",
       "      <th>企业公示的联系电话</th>\n",
       "      <th>企业公示的联系电话（更多号码）</th>\n",
       "      <th>企业公示的地址</th>\n",
       "      <th>企业公示的网址</th>\n",
       "      <th>企业公示的邮箱</th>\n",
       "      <th>经营范围</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>徐州天然润滑油有限公司</td>\n",
       "      <td>郝玉侠</td>\n",
       "      <td>300万元人民币</td>\n",
       "      <td>2012-11-05</td>\n",
       "      <td>在业</td>\n",
       "      <td>江苏省</td>\n",
       "      <td>徐州市</td>\n",
       "      <td>沛县</td>\n",
       "      <td>有限责任公司(自然人独资)</td>\n",
       "      <td>913203220566129545</td>\n",
       "      <td>0516-89927755</td>\n",
       "      <td>0561-89927755;13913496688</td>\n",
       "      <td>沛县龙固镇工业园区</td>\n",
       "      <td>-</td>\n",
       "      <td>1276168519@qq.com</td>\n",
       "      <td>润滑油批发、零售，利用废矿物油加工、销售。（依法须经批准的项目，经相关部门批准后方可开展经营活动）</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>徐州信德塑业有限公司</td>\n",
       "      <td>曾少露</td>\n",
       "      <td>1000万元人民币</td>\n",
       "      <td>2012-12-06</td>\n",
       "      <td>在业</td>\n",
       "      <td>江苏省</td>\n",
       "      <td>徐州市</td>\n",
       "      <td>沛县</td>\n",
       "      <td>有限责任公司(自然人投资或控股)</td>\n",
       "      <td>913203220586436073</td>\n",
       "      <td>15152036569</td>\n",
       "      <td>13852022215;18751612588</td>\n",
       "      <td>沛县安国镇周田工业园区</td>\n",
       "      <td>-</td>\n",
       "      <td>77712522@qq.com</td>\n",
       "      <td>塑料编织袋加工销售，塑料加工专用设备制造、销售。（依法须经批准的项目，经相关部门批准后方可开...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>江苏桂龙生物技术有限公司</td>\n",
       "      <td>许明</td>\n",
       "      <td>1000万人民币</td>\n",
       "      <td>2013-01-25</td>\n",
       "      <td>存续（在营、开业、在册）</td>\n",
       "      <td>江苏省</td>\n",
       "      <td>徐州市</td>\n",
       "      <td>沛县</td>\n",
       "      <td>有限责任公司(自然人独资)</td>\n",
       "      <td>91320322061828944F</td>\n",
       "      <td>0516-89622786</td>\n",
       "      <td>13902588658;18761466088;89622786</td>\n",
       "      <td>沛县工业园区1号路南侧</td>\n",
       "      <td>-</td>\n",
       "      <td>770248165@qq.com</td>\n",
       "      <td>配合饲料（畜禽）、浓缩饲料（畜禽）、复合预混合饲料（畜禽水产）生产、销售，生物技术推广服务，...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>江苏桂柳牧业集团有限公司</td>\n",
       "      <td>鲁荣乾</td>\n",
       "      <td>10000万人民币</td>\n",
       "      <td>2013-03-11</td>\n",
       "      <td>存续（在营、开业、在册）</td>\n",
       "      <td>江苏省</td>\n",
       "      <td>徐州市</td>\n",
       "      <td>沛县</td>\n",
       "      <td>有限责任公司（自然人投资或控股的法人独资）</td>\n",
       "      <td>91320322063254032C</td>\n",
       "      <td>18115729799</td>\n",
       "      <td>0516-81210995</td>\n",
       "      <td>沛县汉祥路东，雨佳服饰北</td>\n",
       "      <td>www.gxgljtoa.cn</td>\n",
       "      <td>glpxslc14@163.com</td>\n",
       "      <td>配合饲料（畜禽）、浓缩饲料（畜禽）生产销售，生物科学技术研究服务，家禽繁育、孵化、养殖、销售...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>江苏慧博灌排设备有限公司</td>\n",
       "      <td>魏忠玲</td>\n",
       "      <td>3060万人民币</td>\n",
       "      <td>2013-04-26</td>\n",
       "      <td>存续（在营、开业、在册）</td>\n",
       "      <td>江苏省</td>\n",
       "      <td>徐州市</td>\n",
       "      <td>沛县</td>\n",
       "      <td>有限责任公司(自然人投资或控股)</td>\n",
       "      <td>913203220676101101</td>\n",
       "      <td>18914842000</td>\n",
       "      <td>0516-81291999;13585485588</td>\n",
       "      <td>沛县张庄镇工业园区</td>\n",
       "      <td>www.jshbgp.com</td>\n",
       "      <td>18914842000@163.com</td>\n",
       "      <td>泵及真空设备、喷灌机、微灌设备、滴灌设备、移管、移动式喷灌设备、农业机械、施肥机械、植保机械...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           公司名称 法定代表人       注册资本        成立日期          经营状态 所属省份 所属市区 所属区县  \\\n",
       "0   徐州天然润滑油有限公司   郝玉侠   300万元人民币  2012-11-05            在业  江苏省  徐州市   沛县   \n",
       "1    徐州信德塑业有限公司   曾少露  1000万元人民币  2012-12-06            在业  江苏省  徐州市   沛县   \n",
       "2  江苏桂龙生物技术有限公司    许明   1000万人民币  2013-01-25  存续（在营、开业、在册）  江苏省  徐州市   沛县   \n",
       "3  江苏桂柳牧业集团有限公司   鲁荣乾  10000万人民币  2013-03-11  存续（在营、开业、在册）  江苏省  徐州市   沛县   \n",
       "4  江苏慧博灌排设备有限公司   魏忠玲   3060万人民币  2013-04-26  存续（在营、开业、在册）  江苏省  徐州市   沛县   \n",
       "\n",
       "                    公司类型              统一信用代码      企业公示的联系电话  \\\n",
       "0          有限责任公司(自然人独资)  913203220566129545  0516-89927755   \n",
       "1       有限责任公司(自然人投资或控股)  913203220586436073    15152036569   \n",
       "2          有限责任公司(自然人独资)  91320322061828944F  0516-89622786   \n",
       "3  有限责任公司（自然人投资或控股的法人独资）  91320322063254032C    18115729799   \n",
       "4       有限责任公司(自然人投资或控股)  913203220676101101    18914842000   \n",
       "\n",
       "                    企业公示的联系电话（更多号码）       企业公示的地址          企业公示的网址  \\\n",
       "0         0561-89927755;13913496688     沛县龙固镇工业园区                -   \n",
       "1           13852022215;18751612588   沛县安国镇周田工业园区                -   \n",
       "2  13902588658;18761466088;89622786   沛县工业园区1号路南侧                -   \n",
       "3                     0516-81210995  沛县汉祥路东，雨佳服饰北  www.gxgljtoa.cn   \n",
       "4         0516-81291999;13585485588     沛县张庄镇工业园区   www.jshbgp.com   \n",
       "\n",
       "               企业公示的邮箱                                               经营范围  \n",
       "0    1276168519@qq.com  润滑油批发、零售，利用废矿物油加工、销售。（依法须经批准的项目，经相关部门批准后方可开展经营活动）  \n",
       "1      77712522@qq.com  塑料编织袋加工销售，塑料加工专用设备制造、销售。（依法须经批准的项目，经相关部门批准后方可开...  \n",
       "2     770248165@qq.com  配合饲料（畜禽）、浓缩饲料（畜禽）、复合预混合饲料（畜禽水产）生产、销售，生物技术推广服务，...  \n",
       "3    glpxslc14@163.com  配合饲料（畜禽）、浓缩饲料（畜禽）生产销售，生物科学技术研究服务，家禽繁育、孵化、养殖、销售...  \n",
       "4  18914842000@163.com  泵及真空设备、喷灌机、微灌设备、滴灌设备、移管、移动式喷灌设备、农业机械、施肥机械、植保机械...  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "key_word = ['龙固','杨屯','大屯','沛城','胡寨','魏庙','五段','张庄','张寨','敬安','河口','栖山','鹿楼','朱寨','安国','开发区']\n",
    "for i in key_word:\n",
    "    str = '(?=.*{})'.format(i)\n",
    "    df.loc[df['企业公示的地址'].str.contains(str),'乡镇']=i"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>公司名称</th>\n",
       "      <th>法定代表人</th>\n",
       "      <th>注册资本</th>\n",
       "      <th>成立日期</th>\n",
       "      <th>经营状态</th>\n",
       "      <th>所属省份</th>\n",
       "      <th>所属市区</th>\n",
       "      <th>所属区县</th>\n",
       "      <th>公司类型</th>\n",
       "      <th>统一信用代码</th>\n",
       "      <th>企业公示的联系电话</th>\n",
       "      <th>企业公示的联系电话（更多号码）</th>\n",
       "      <th>企业公示的地址</th>\n",
       "      <th>企业公示的网址</th>\n",
       "      <th>企业公示的邮箱</th>\n",
       "      <th>经营范围</th>\n",
       "      <th>乡镇</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>徐州天然润滑油有限公司</td>\n",
       "      <td>郝玉侠</td>\n",
       "      <td>300万元人民币</td>\n",
       "      <td>2012-11-05</td>\n",
       "      <td>在业</td>\n",
       "      <td>江苏省</td>\n",
       "      <td>徐州市</td>\n",
       "      <td>沛县</td>\n",
       "      <td>有限责任公司(自然人独资)</td>\n",
       "      <td>913203220566129545</td>\n",
       "      <td>0516-89927755</td>\n",
       "      <td>0561-89927755;13913496688</td>\n",
       "      <td>沛县龙固镇工业园区</td>\n",
       "      <td>-</td>\n",
       "      <td>1276168519@qq.com</td>\n",
       "      <td>润滑油批发、零售，利用废矿物油加工、销售。（依法须经批准的项目，经相关部门批准后方可开展经营活动）</td>\n",
       "      <td>龙固</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>徐州信德塑业有限公司</td>\n",
       "      <td>曾少露</td>\n",
       "      <td>1000万元人民币</td>\n",
       "      <td>2012-12-06</td>\n",
       "      <td>在业</td>\n",
       "      <td>江苏省</td>\n",
       "      <td>徐州市</td>\n",
       "      <td>沛县</td>\n",
       "      <td>有限责任公司(自然人投资或控股)</td>\n",
       "      <td>913203220586436073</td>\n",
       "      <td>15152036569</td>\n",
       "      <td>13852022215;18751612588</td>\n",
       "      <td>沛县安国镇周田工业园区</td>\n",
       "      <td>-</td>\n",
       "      <td>77712522@qq.com</td>\n",
       "      <td>塑料编织袋加工销售，塑料加工专用设备制造、销售。（依法须经批准的项目，经相关部门批准后方可开...</td>\n",
       "      <td>安国</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>江苏桂龙生物技术有限公司</td>\n",
       "      <td>许明</td>\n",
       "      <td>1000万人民币</td>\n",
       "      <td>2013-01-25</td>\n",
       "      <td>存续（在营、开业、在册）</td>\n",
       "      <td>江苏省</td>\n",
       "      <td>徐州市</td>\n",
       "      <td>沛县</td>\n",
       "      <td>有限责任公司(自然人独资)</td>\n",
       "      <td>91320322061828944F</td>\n",
       "      <td>0516-89622786</td>\n",
       "      <td>13902588658;18761466088;89622786</td>\n",
       "      <td>沛县工业园区1号路南侧</td>\n",
       "      <td>-</td>\n",
       "      <td>770248165@qq.com</td>\n",
       "      <td>配合饲料（畜禽）、浓缩饲料（畜禽）、复合预混合饲料（畜禽水产）生产、销售，生物技术推广服务，...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>江苏桂柳牧业集团有限公司</td>\n",
       "      <td>鲁荣乾</td>\n",
       "      <td>10000万人民币</td>\n",
       "      <td>2013-03-11</td>\n",
       "      <td>存续（在营、开业、在册）</td>\n",
       "      <td>江苏省</td>\n",
       "      <td>徐州市</td>\n",
       "      <td>沛县</td>\n",
       "      <td>有限责任公司（自然人投资或控股的法人独资）</td>\n",
       "      <td>91320322063254032C</td>\n",
       "      <td>18115729799</td>\n",
       "      <td>0516-81210995</td>\n",
       "      <td>沛县汉祥路东，雨佳服饰北</td>\n",
       "      <td>www.gxgljtoa.cn</td>\n",
       "      <td>glpxslc14@163.com</td>\n",
       "      <td>配合饲料（畜禽）、浓缩饲料（畜禽）生产销售，生物科学技术研究服务，家禽繁育、孵化、养殖、销售...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>江苏慧博灌排设备有限公司</td>\n",
       "      <td>魏忠玲</td>\n",
       "      <td>3060万人民币</td>\n",
       "      <td>2013-04-26</td>\n",
       "      <td>存续（在营、开业、在册）</td>\n",
       "      <td>江苏省</td>\n",
       "      <td>徐州市</td>\n",
       "      <td>沛县</td>\n",
       "      <td>有限责任公司(自然人投资或控股)</td>\n",
       "      <td>913203220676101101</td>\n",
       "      <td>18914842000</td>\n",
       "      <td>0516-81291999;13585485588</td>\n",
       "      <td>沛县张庄镇工业园区</td>\n",
       "      <td>www.jshbgp.com</td>\n",
       "      <td>18914842000@163.com</td>\n",
       "      <td>泵及真空设备、喷灌机、微灌设备、滴灌设备、移管、移动式喷灌设备、农业机械、施肥机械、植保机械...</td>\n",
       "      <td>张庄</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           公司名称 法定代表人       注册资本        成立日期          经营状态 所属省份 所属市区 所属区县  \\\n",
       "0   徐州天然润滑油有限公司   郝玉侠   300万元人民币  2012-11-05            在业  江苏省  徐州市   沛县   \n",
       "1    徐州信德塑业有限公司   曾少露  1000万元人民币  2012-12-06            在业  江苏省  徐州市   沛县   \n",
       "2  江苏桂龙生物技术有限公司    许明   1000万人民币  2013-01-25  存续（在营、开业、在册）  江苏省  徐州市   沛县   \n",
       "3  江苏桂柳牧业集团有限公司   鲁荣乾  10000万人民币  2013-03-11  存续（在营、开业、在册）  江苏省  徐州市   沛县   \n",
       "4  江苏慧博灌排设备有限公司   魏忠玲   3060万人民币  2013-04-26  存续（在营、开业、在册）  江苏省  徐州市   沛县   \n",
       "\n",
       "                    公司类型              统一信用代码      企业公示的联系电话  \\\n",
       "0          有限责任公司(自然人独资)  913203220566129545  0516-89927755   \n",
       "1       有限责任公司(自然人投资或控股)  913203220586436073    15152036569   \n",
       "2          有限责任公司(自然人独资)  91320322061828944F  0516-89622786   \n",
       "3  有限责任公司（自然人投资或控股的法人独资）  91320322063254032C    18115729799   \n",
       "4       有限责任公司(自然人投资或控股)  913203220676101101    18914842000   \n",
       "\n",
       "                    企业公示的联系电话（更多号码）       企业公示的地址          企业公示的网址  \\\n",
       "0         0561-89927755;13913496688     沛县龙固镇工业园区                -   \n",
       "1           13852022215;18751612588   沛县安国镇周田工业园区                -   \n",
       "2  13902588658;18761466088;89622786   沛县工业园区1号路南侧                -   \n",
       "3                     0516-81210995  沛县汉祥路东，雨佳服饰北  www.gxgljtoa.cn   \n",
       "4         0516-81291999;13585485588     沛县张庄镇工业园区   www.jshbgp.com   \n",
       "\n",
       "               企业公示的邮箱                                               经营范围   乡镇  \n",
       "0    1276168519@qq.com  润滑油批发、零售，利用废矿物油加工、销售。（依法须经批准的项目，经相关部门批准后方可开展经营活动）   龙固  \n",
       "1      77712522@qq.com  塑料编织袋加工销售，塑料加工专用设备制造、销售。（依法须经批准的项目，经相关部门批准后方可开...   安国  \n",
       "2     770248165@qq.com  配合饲料（畜禽）、浓缩饲料（畜禽）、复合预混合饲料（畜禽水产）生产、销售，生物技术推广服务，...  NaN  \n",
       "3    glpxslc14@163.com  配合饲料（畜禽）、浓缩饲料（畜禽）生产销售，生物科学技术研究服务，家禽繁育、孵化、养殖、销售...  NaN  \n",
       "4  18914842000@163.com  泵及真空设备、喷灌机、微灌设备、滴灌设备、移管、移动式喷灌设备、农业机械、施肥机械、植保机械...   张庄  "
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>公司名称</th>\n",
       "      <th>法定代表人</th>\n",
       "      <th>注册资本</th>\n",
       "      <th>成立日期</th>\n",
       "      <th>经营状态</th>\n",
       "      <th>所属省份</th>\n",
       "      <th>所属市区</th>\n",
       "      <th>所属区县</th>\n",
       "      <th>公司类型</th>\n",
       "      <th>统一信用代码</th>\n",
       "      <th>企业公示的联系电话</th>\n",
       "      <th>企业公示的联系电话（更多号码）</th>\n",
       "      <th>企业公示的地址</th>\n",
       "      <th>企业公示的网址</th>\n",
       "      <th>企业公示的邮箱</th>\n",
       "      <th>经营范围</th>\n",
       "      <th>乡镇</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>江苏桂龙生物技术有限公司</td>\n",
       "      <td>许明</td>\n",
       "      <td>1000万人民币</td>\n",
       "      <td>2013-01-25</td>\n",
       "      <td>存续（在营、开业、在册）</td>\n",
       "      <td>江苏省</td>\n",
       "      <td>徐州市</td>\n",
       "      <td>沛县</td>\n",
       "      <td>有限责任公司(自然人独资)</td>\n",
       "      <td>91320322061828944F</td>\n",
       "      <td>0516-89622786</td>\n",
       "      <td>13902588658;18761466088;89622786</td>\n",
       "      <td>沛县工业园区1号路南侧</td>\n",
       "      <td>-</td>\n",
       "      <td>770248165@qq.com</td>\n",
       "      <td>配合饲料（畜禽）、浓缩饲料（畜禽）、复合预混合饲料（畜禽水产）生产、销售，生物技术推广服务，...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>江苏桂柳牧业集团有限公司</td>\n",
       "      <td>鲁荣乾</td>\n",
       "      <td>10000万人民币</td>\n",
       "      <td>2013-03-11</td>\n",
       "      <td>存续（在营、开业、在册）</td>\n",
       "      <td>江苏省</td>\n",
       "      <td>徐州市</td>\n",
       "      <td>沛县</td>\n",
       "      <td>有限责任公司（自然人投资或控股的法人独资）</td>\n",
       "      <td>91320322063254032C</td>\n",
       "      <td>18115729799</td>\n",
       "      <td>0516-81210995</td>\n",
       "      <td>沛县汉祥路东，雨佳服饰北</td>\n",
       "      <td>www.gxgljtoa.cn</td>\n",
       "      <td>glpxslc14@163.com</td>\n",
       "      <td>配合饲料（畜禽）、浓缩饲料（畜禽）生产销售，生物科学技术研究服务，家禽繁育、孵化、养殖、销售...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>东方希望（徐州）动物食品有限公司</td>\n",
       "      <td>黄健</td>\n",
       "      <td>1500万元人民币</td>\n",
       "      <td>1994-10-20</td>\n",
       "      <td>在业</td>\n",
       "      <td>江苏省</td>\n",
       "      <td>徐州市</td>\n",
       "      <td>沛县</td>\n",
       "      <td>有限责任公司（非自然人投资或控股的法人独资）</td>\n",
       "      <td>913203221368715265</td>\n",
       "      <td>13225295679</td>\n",
       "      <td>0516-89615020;0516-89627202;0516-89682180</td>\n",
       "      <td>沛县沛龙公路2号</td>\n",
       "      <td>-</td>\n",
       "      <td>xzxw@easthope.cn</td>\n",
       "      <td>饲料、饲料添加剂生产、销售；养殖、种禽、种畜食品加工、土特产品、粮食制品购销；粮食收购；饲料...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>徐州中基混凝土有限公司</td>\n",
       "      <td>翟允五</td>\n",
       "      <td>1000万元人民币</td>\n",
       "      <td>2007-11-08</td>\n",
       "      <td>在业</td>\n",
       "      <td>江苏省</td>\n",
       "      <td>徐州市</td>\n",
       "      <td>沛县</td>\n",
       "      <td>有限责任公司(自然人投资或控股)</td>\n",
       "      <td>91320322668961653T</td>\n",
       "      <td>18036363099</td>\n",
       "      <td>0516-89678728</td>\n",
       "      <td>沛县正阳南路东侧紫荆花园17号楼42室</td>\n",
       "      <td>www.xzzjhnt.com</td>\n",
       "      <td>360283554@qq.com</td>\n",
       "      <td>商品混凝土加工、销售；钢材、建材、砂石料、五金产品、电气设备销售。（依法须经批准的项目，经相...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>114</th>\n",
       "      <td>徐州华隆织染有限公司</td>\n",
       "      <td>陈伟能</td>\n",
       "      <td>2000万元人民币</td>\n",
       "      <td>2004-06-29</td>\n",
       "      <td>在业</td>\n",
       "      <td>江苏省</td>\n",
       "      <td>徐州市</td>\n",
       "      <td>沛县</td>\n",
       "      <td>有限责任公司(自然人投资或控股)</td>\n",
       "      <td>91320322764177893B</td>\n",
       "      <td>0516-89681189</td>\n",
       "      <td>89681188</td>\n",
       "      <td>沛县工业园区酒厂西路西侧沛丰路北侧</td>\n",
       "      <td>-</td>\n",
       "      <td>405404449@qq.com</td>\n",
       "      <td>棉、化纤纺织加工销售；纱线布、人造革、鞋帽服装、纺织原料、纺织品销售，百货仓储服务。（依法须...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>146</th>\n",
       "      <td>江苏鑫福纤维科技有限公司</td>\n",
       "      <td>张洪文</td>\n",
       "      <td>1000万美元</td>\n",
       "      <td>2010-04-12</td>\n",
       "      <td>在业</td>\n",
       "      <td>江苏省</td>\n",
       "      <td>徐州市</td>\n",
       "      <td>沛县</td>\n",
       "      <td>有限责任公司(台港澳法人独资)</td>\n",
       "      <td>9132030055375403XP</td>\n",
       "      <td>0516-81208000</td>\n",
       "      <td>13395260893;0516-81208111;68876996</td>\n",
       "      <td>沛县汉韵路西</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>涤纶纤维制造，棉、化纤纺织加工；销售自产产品。（依法须经批准的项目，经相关部门批准后方可开展...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>155</th>\n",
       "      <td>徐州海阔六和饲料有限公司</td>\n",
       "      <td>蒲彬</td>\n",
       "      <td>1400万元人民币</td>\n",
       "      <td>2007-12-25</td>\n",
       "      <td>在业</td>\n",
       "      <td>江苏省</td>\n",
       "      <td>徐州市</td>\n",
       "      <td>沛县</td>\n",
       "      <td>有限责任公司（自然人投资或控股的法人独资）</td>\n",
       "      <td>9132032267013258XL</td>\n",
       "      <td>0516-89888388</td>\n",
       "      <td>0516-89888778</td>\n",
       "      <td>沛县工业园区</td>\n",
       "      <td>www.newhopegroup.com</td>\n",
       "      <td>hklh.sd@newhope.cn</td>\n",
       "      <td>配合饲料、浓缩饲料生产销售；自用粮食的收购，水质改良剂（危险化学品除外）销售，猪、羊、牛、鸡...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>156</th>\n",
       "      <td>江苏佳汉纺织科技有限公司</td>\n",
       "      <td>洪燕您</td>\n",
       "      <td>2000万美元</td>\n",
       "      <td>2009-12-10</td>\n",
       "      <td>在业</td>\n",
       "      <td>江苏省</td>\n",
       "      <td>徐州市</td>\n",
       "      <td>沛县</td>\n",
       "      <td>有限责任公司(外国法人独资)</td>\n",
       "      <td>9132030069789463XP</td>\n",
       "      <td>0516-89895599</td>\n",
       "      <td>0516-89755777</td>\n",
       "      <td>沛县东风西路58号</td>\n",
       "      <td>www.joinhandcn.com</td>\n",
       "      <td>swd8888@126.com</td>\n",
       "      <td>纺织服装研发制造，纺织面料鞋、帽制造；销售自产产品。（依法须经批准的项目，经相关部门批准后方...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>160</th>\n",
       "      <td>徐州忠意海阔食品有限公司</td>\n",
       "      <td>朱广龙</td>\n",
       "      <td>1224.5万元人民币</td>\n",
       "      <td>2005-04-30</td>\n",
       "      <td>在业</td>\n",
       "      <td>江苏省</td>\n",
       "      <td>徐州市</td>\n",
       "      <td>沛县</td>\n",
       "      <td>有限责任公司（自然人投资或控股的法人独资）</td>\n",
       "      <td>9132032277248288XU</td>\n",
       "      <td>0516-89682726</td>\n",
       "      <td>89682726</td>\n",
       "      <td>沛县工业园区裴塘新村西侧</td>\n",
       "      <td>-</td>\n",
       "      <td>1020601556@qq.com</td>\n",
       "      <td>禽类加工，羽绒及其制品加工销售，蔬菜保鲜销售，农作物种植，畜禽饲养，饲料销售，企业管理信息咨...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                 公司名称 法定代表人         注册资本        成立日期          经营状态 所属省份 所属市区  \\\n",
       "2        江苏桂龙生物技术有限公司    许明     1000万人民币  2013-01-25  存续（在营、开业、在册）  江苏省  徐州市   \n",
       "3        江苏桂柳牧业集团有限公司   鲁荣乾    10000万人民币  2013-03-11  存续（在营、开业、在册）  江苏省  徐州市   \n",
       "12   东方希望（徐州）动物食品有限公司    黄健    1500万元人民币  1994-10-20            在业  江苏省  徐州市   \n",
       "81        徐州中基混凝土有限公司   翟允五    1000万元人民币  2007-11-08            在业  江苏省  徐州市   \n",
       "114        徐州华隆织染有限公司   陈伟能    2000万元人民币  2004-06-29            在业  江苏省  徐州市   \n",
       "146      江苏鑫福纤维科技有限公司   张洪文      1000万美元  2010-04-12            在业  江苏省  徐州市   \n",
       "155      徐州海阔六和饲料有限公司    蒲彬    1400万元人民币  2007-12-25            在业  江苏省  徐州市   \n",
       "156      江苏佳汉纺织科技有限公司   洪燕您      2000万美元  2009-12-10            在业  江苏省  徐州市   \n",
       "160      徐州忠意海阔食品有限公司   朱广龙  1224.5万元人民币  2005-04-30            在业  江苏省  徐州市   \n",
       "\n",
       "    所属区县                    公司类型              统一信用代码      企业公示的联系电话  \\\n",
       "2     沛县           有限责任公司(自然人独资)  91320322061828944F  0516-89622786   \n",
       "3     沛县   有限责任公司（自然人投资或控股的法人独资）  91320322063254032C    18115729799   \n",
       "12    沛县  有限责任公司（非自然人投资或控股的法人独资）  913203221368715265    13225295679   \n",
       "81    沛县        有限责任公司(自然人投资或控股)  91320322668961653T    18036363099   \n",
       "114   沛县        有限责任公司(自然人投资或控股)  91320322764177893B  0516-89681189   \n",
       "146   沛县         有限责任公司(台港澳法人独资)  9132030055375403XP  0516-81208000   \n",
       "155   沛县   有限责任公司（自然人投资或控股的法人独资）  9132032267013258XL  0516-89888388   \n",
       "156   沛县          有限责任公司(外国法人独资)  9132030069789463XP  0516-89895599   \n",
       "160   沛县   有限责任公司（自然人投资或控股的法人独资）  9132032277248288XU  0516-89682726   \n",
       "\n",
       "                               企业公示的联系电话（更多号码）              企业公示的地址  \\\n",
       "2             13902588658;18761466088;89622786          沛县工业园区1号路南侧   \n",
       "3                                0516-81210995         沛县汉祥路东，雨佳服饰北   \n",
       "12   0516-89615020;0516-89627202;0516-89682180             沛县沛龙公路2号   \n",
       "81                               0516-89678728  沛县正阳南路东侧紫荆花园17号楼42室   \n",
       "114                                   89681188    沛县工业园区酒厂西路西侧沛丰路北侧   \n",
       "146         13395260893;0516-81208111;68876996               沛县汉韵路西   \n",
       "155                              0516-89888778               沛县工业园区   \n",
       "156                              0516-89755777            沛县东风西路58号   \n",
       "160                                   89682726         沛县工业园区裴塘新村西侧   \n",
       "\n",
       "                  企业公示的网址             企业公示的邮箱  \\\n",
       "2                       -    770248165@qq.com   \n",
       "3         www.gxgljtoa.cn   glpxslc14@163.com   \n",
       "12                      -    xzxw@easthope.cn   \n",
       "81        www.xzzjhnt.com    360283554@qq.com   \n",
       "114                     -    405404449@qq.com   \n",
       "146                     -                   -   \n",
       "155  www.newhopegroup.com  hklh.sd@newhope.cn   \n",
       "156    www.joinhandcn.com     swd8888@126.com   \n",
       "160                     -   1020601556@qq.com   \n",
       "\n",
       "                                                  经营范围   乡镇  \n",
       "2    配合饲料（畜禽）、浓缩饲料（畜禽）、复合预混合饲料（畜禽水产）生产、销售，生物技术推广服务，...  NaN  \n",
       "3    配合饲料（畜禽）、浓缩饲料（畜禽）生产销售，生物科学技术研究服务，家禽繁育、孵化、养殖、销售...  NaN  \n",
       "12   饲料、饲料添加剂生产、销售；养殖、种禽、种畜食品加工、土特产品、粮食制品购销；粮食收购；饲料...  NaN  \n",
       "81   商品混凝土加工、销售；钢材、建材、砂石料、五金产品、电气设备销售。（依法须经批准的项目，经相...  NaN  \n",
       "114  棉、化纤纺织加工销售；纱线布、人造革、鞋帽服装、纺织原料、纺织品销售，百货仓储服务。（依法须...  NaN  \n",
       "146  涤纶纤维制造，棉、化纤纺织加工；销售自产产品。（依法须经批准的项目，经相关部门批准后方可开展...  NaN  \n",
       "155  配合饲料、浓缩饲料生产销售；自用粮食的收购，水质改良剂（危险化学品除外）销售，猪、羊、牛、鸡...  NaN  \n",
       "156  纺织服装研发制造，纺织面料鞋、帽制造；销售自产产品。（依法须经批准的项目，经相关部门批准后方...  NaN  \n",
       "160  禽类加工，羽绒及其制品加工销售，蔬菜保鲜销售，农作物种植，畜禽饲养，饲料销售，企业管理信息咨...  NaN  "
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.loc[df['乡镇'].isnull()]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_csv('result.csv',encoding=\"utf_8_sig\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}
